query= 
-- _f_propiedades.php listar_propiedades()
			SELECT
			*
			FROM propiedad
			WHERE
		
		 web = 100 -- std
		

 -- cond_empresa 

 AND cod_empresa		= 288 -- mif
		
		AND (
				-- propiedades de empresas no excluidas de MLS
				(
					(web, cod_empresa) NOT IN (
						SELECT web_cap, cod_empresa_cap
						FROM empresa_config_mls
						WHERE web = 100
							AND cod_empresa = 288
							AND cod_propiedad IS NULL
							AND estado = 'C'
					)
				)
				AND
				-- propiedades no excluidas de MLS
				(
					cod_propiedad NOT IN (
						SELECT cod_propiedad
						FROM empresa_config_mls
						WHERE web = 100
							AND cod_empresa = 288
							AND cod_propiedad IS NOT NULL
							AND estado = 'C'
					)
				)
				AND
				-- propiedades no excluidas de MLS a nivel global (por usuario administrador de MLS 20230626a)
				(
					cod_propiedad NOT IN (
						SELECT cod_propiedad
						FROM empresa_config_mls
						WHERE estado = 'X'
					)
				)
			)
		
		-- 20141219 rbz [MLSxx] Inclusión propiedades de Re-max e In-Max en LP360
		 -- nop!
		AND propiedad.cod_oficina			= 0

		AND ( cod_empresa != 1 OR  1=2  )		-- ceidemo 1 && 

		

		AND propiedad.cod_propiedad NOT IN (0)

		

		

		
		AND (
				( propiedad.estado			IN ('A','O','B') )
			||	( propiedad.estado			IN ('V','R') AND fecha_ult_mod > '20240424' AND NOT  1=2 )		-- Vendidas y alquiladas se muestran en webs publicas n_dias despues de la operacion
			||	( propiedad.estado			= 'V' AND 0 =1 )
			||	( propiedad.estado			= 'R' AND 0 =1 )
			||	( propiedad.estado			= '3' AND 0 =1 )
			||	( propiedad.estado			= '4' AND 0 =1 )
			||	( propiedad.estado			= 'C' AND 0 =1 )
		--	|| 	( propiedad.estado			= 'P' AND  1=2  )	-- Prospeccion
			||	( propiedad.estado			= 'P' AND 0 =1 )
			||	( propiedad.estado			= 'B' AND 0 =1 )
			)
		
	
		
		AND   -- propiedades no publicadas
			(
				 propiedad.publicar IN ('S','P') -- TIPO_WEB_PORTAL
			)
	  	
				AND (
							( propiedad.tipo_operacion	= '' )															-- El tipo_operacion de la propiedad coincide con el indicado por el usuario
						||	( propiedad.tipo_operacion	IN ('V','A')  && '' = 'X' )										-- El tipo_operacion de la propiedad es Venta o Alquiler y el indicado por el usuario es X
						||	( propiedad.tipo_operacion	= 'X'  && ('' = 'V' || '' = 'A') )	-- El tipo_operacion de la propiedad es X y el indicado por el usuario es Venta o Alquiler
						||	( ''	= '' )								-- El usuario no ha seleccionado tipo_operacion, mostramos todo
						-- [20180806d]
						||	( propiedad.tipo_operacion	IN ('H')  && '' = 'C' )											-- El tipo_operacion de la propiedad es Alquiler vacacional y el indicado por el usuario es C (alquiler de corta duracion)
					 )
				AND (
						  cod_valoracion = ''
						||
						  '' = ''
					 )

				-- cond_pais
				

				-- cond_zonas
				 AND ( propiedad.cod_metazona IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61   ,99) ) 

				-- 20180806d
				
				
					-- cond_metazonas_portales
					
					-- cond_metazonas_portales: ERROR!! NO OBSERVADO PORTAL 100
				
					
				
				
				AND (
					 	( propiedad.metatipo_propiedad	= '' )	-- el metatipo_propiedad es el seleccionado
					 	||
					 	( '' = '' )
					 )
				AND (
					 	( propiedad.tipo_propiedad	IN (0) )	-- el tipo de propiedad es el seleccionado
					 	||
					 	( ( '0' = '' || '0' = 0 ) )   -- 20120820 rbz Incluimos negocios en home, además es necesario para que salgan cuando no se indica tipo_propiedad 			  && tipo_propiedad < 200 )	-- No se seleccionó tipo_propiedad (página inicial) No pintamos parcelas, negocios...
					 	||
					 	( ( '0' = '' || '0' = 0 ) && '' = 3 )	-- inversiones
					 )

			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			AND ( propiedad.superficie			>= ''			|| '' = '' )
			AND ( propiedad.superficie			<= ''			|| '' = '' )
			AND ( propiedad.superficie_util		>= ''		|| '' = '' )
			AND ( propiedad.superficie_util		<= ''		|| '' = '' )
			AND ( propiedad.superficie_parcela	>= ''	|| '' = '' )
			AND ( propiedad.superficie_parcela	<= ''	|| '' = '' )
			AND propiedad.fecha_alta			<= '20240509'
			
						AND
							(	-- Usuario busca Venta/Alquiler (o no selecciona tipo_operacion)
								--	propiedad.tipo_operacion IN ('V','A','X')
								 	( propiedad.precio_pvp		<= ''	|| propiedad.precio_pvp	  IS NULL			|| '' = '' 	|| '' = '0' )
								&&	( propiedad.precio_pvp		>= ''	|| propiedad.precio_pvp	  IS NULL			|| '' = '' 	|| '' = '0' )

								&&	( propiedad.precio_alquiler	<= ''	|| propiedad.precio_alquiler IS NULL			|| '' = ''	|| '' = '0' )
								&&	( propiedad.precio_alquiler	>= ''	|| propiedad.precio_alquiler IS NULL			|| '' = ''	|| '' = '0' )
						)
							
		
		-- 20131223 rbz
		
		-- 20130128 rbz
		
		
		-- 20130916 rbz [20130131a]
		
		-- 20130506 rbz
		
		
		-- [20160430a]
		
		
		
		-- 20131028 rbz [20131028a]
		
		
		
		
		-- 20131220 rbz [20131220a]
		
		
		-- 20130514 rbz [20130514a]
		
		-- 20180305b
		
		-- [3370-4320]
		
		
	
 AND propiedad.num_fotos >= 1
 AND cod_propiedad NOT IN (1111) -- propiedades_especialitas_excluidas

	  	

	ORDER BY 
				CASE
					WHEN web = 100 AND cod_empresa = 288 THEN 1	-- propiedades de la propia empresa-
					ELSE 9
				END,
				
			CASE
				WHEN web = 100 AND cod_empresa = 288 THEN prioridad 	-- propiedades de la propia empresa
				-- ELSE 999  -- no deberia ser -1?
				ELSE -1
			END DESC
			,     -- 20220315 rbz Añado criterio prioridad (Thorsgren quería para que sus propiedades aparecieran antes que resales)
				   -- 20220315 rbz Añado este criterio para que las propiedades de MLS aparezcan ordenadas según la empresa asociada
				 cod_propiedad DESC -- 11 
	
 LIMIT 99999 -- * 
 -- num_prop_slide= grupo_registros=0 num_max_propiedades_x_pagina=24
 OFFSET 0 -- 3 offp

num_tuplas= 
483

Someso, Coruña (A), La Coruña (A Coruña)

Parking space for sale

15

RefRASO-486387 🔗

Ref2.SBRE-0163835

JUST IN

from 1.900€

Calle Luis Peña Novo, 8

Reference:

486387 - SBRE-0163835

Size:

10m²

Usable size:

6m²

Floor:

Basement -2

Basement:

Yes

Details and photos

Montealto, Coruña (A), La Coruña (A Coruña)

Parking space for sale

7

RefRASO-486386 🔗

Ref2.SBRE-0158104

JUST IN

3.000€

Calle Adelaida Muro, 8

Reference:

486386 - SBRE-0158104

Size:

5m²

Usable size:

5m²

Storage room:

No

Basement:

No

Details and photos

Someso, Coruña (A), La Coruña (A Coruña)

Parking space for sale

15

RefRASO-486385 🔗

Ref2.SBRE-0163824

JUST IN

from 1.700€

Calle Luis Peña Novo, 8

Reference:

486385 - SBRE-0163824

Size:

10m²

Usable size:

6m²

Floor:

Basement -1

Basement:

Yes

Details and photos

Lavadores, Lavadoras, Vigo, Pontevedra

House for sale

14

RefRASO-486379 🔗

INVESTORS

115.000€

Calle Paz Pardo

Reference:

486379

Size:

150m²

Usable size:

130m²

Plot size:

207m²

Bedrooms:

2

Bathrooms:

2

Furnished:

Not furnished

Garage:

No

Garden:

Private

Floor:

Street level

Lounges:

2

Independent dining room:

No

Furnished kitchen:

Semi-furnished

Kitchen type:

Independent

Location:

Partially exterior

Orientation:

West

Location:

Residential area

Views:

Street

Ceiling height:

Regular

Walls:

Others

Floors:

Others

Type of windows:

Aluminum

Type of glazing:

Single

Hot water:

Yes

Type hot water:

Butane

No. of floors:

2

Facade:

Others

Condition:

Construction stopped

Availability:

occupied by owner

Equipment:

Water

Details and photos

Juan Flórez, Coruña (A), La Coruña (A Coruña)

Flat for sale

23

RefRASO-478463 🔗

FEATURED

245.000€

Calle POZO

Reference:

478463

Size:

76m²

Usable size:

70m²

Bedrooms:

2

Bathrooms:

1

Furnished:

Not furnished

Garage:

No

Floor:

2nd

Built-in cupboards:

Yes

Furnished kitchen:

Furnished with appliances

Kitchen type:

Independent

Location:

Exterior

Orientation:

Southeast

Location:

City center

Views:

Street

Ceiling height:

High

Type of windows:

Glazed, Oscillating

Type of glazing:

Double glazing, Thermal bridge

Storage room:

No

Hot water:

Yes

Type hot water:

Natural gas

Heating:

Yes

Heating type:

Natural gas

Lift:

No

Condition:

Excellent

Handicapped access:

No

Details and photos

Oia, Pontevedra

House for sale

53 1

RefRASO-461013 🔗

JUST IN

240.000€

Beautiful house in Oia near the sea, with excellent views.

Cozy 85 square meter house for sale with a 500 square meter plot (completely flat) located in Oia, it has beautiful views and proximity to the sea. The house is distributed over two floors as follows: On the ground floor: - 1 Gallery with a seating area and stairs that give access to both the upper floor and the rest of the rooms on this floor. - 1 Room with access to the garden. - 1 full bathroom with shower tray. - 1 Bright living room. - 1 Independent kitchen fully equipped with modern furniture and top brand appliances. Upstairs: - 1 Small gallery/hall that gives access to the rest of the rooms on this floor. - 1 Living room that gives access to the balcony. - 1 Toilet. - 1 bright room. Both the design and the furniture are modern and functional, the appliances are top brands and the hot water is provided by a sealed butane gas heater (with energy classification A). It has an attached building that serves as a warehouse. It has a gazebo (with stone table and seats) and a barbecue where you can enjoy spectacular sunsets. Several cars can be parked on the plot. The house has been almost completely renovated, making it completely suitable for both living and a second home. It is also recommended for investors given its location (given its tourist use). The property is located on urban land but surrounded by rustic land, and a few meters from the coastline, so no building can be built in front of or next to it. Located a few meters from the Camino de Santiago and with good access to the sea, in a quiet area. It's found : 2 km from the Monastery of Oia, 6 km from the Pozas de Mougas, 15 km from Baiona, 16 km from Molinos del Folón and Picón, 20 km from A Guarda and 35 km from Vigo. If you enjoy the sea, this house is for you.

Reference:

461013

Size:

85m²

Usable size:

75,5m²

Plot size:

500m²

Bedrooms:

2

Bathrooms:

1

Furnished:

Fully furnished

Garage:

Private (3 Parking places)

Garage type:

Carport

Garden:

Private (450.00m²)

Lounges:

1

Independent dining room:

No

Furnished kitchen:

Furnished

Kitchen type:

Independent

WCs:

1

Balconies:

1 (4.37m²)

Location:

Exterior

Orientation:

West

Location:

Near the beach, Rural area

Views:

Direct sea, Country, Mountain

Ceiling height:

Regular

Type of ceiling:

Plaster

Finishing carpentry :

Oak, White lacquer

Walls:

Flat

Floors:

Stoneware, Floating wood

Type of windows:

Aluminum, Glazed, Oscillating, Blinds

Type of glazing:

Double glazing

Storage room:

Yes

Hot water:

Yes

Type hot water:

Butane

No. of floors:

2

Style:

Modern

Facade:

Others

Building year:

1985 (39 year/s)

Condition:

Good

Availability:

Unoccupied

Equipment:

Antenna, TV, Internet, Refrigerator, Washing machine, Oven, Microwave, Water, Light, Appliances, Barbecue, Well, Shower plate, , Cellar

IBI:

50€

Details and photos

Plaza Industria, Vigo, Pontevedra

Flat for sale

24 1

RefRASO-451379 🔗

INVESTORS

110.000€

Spacious apartment for sale in Plaza de la Industria

Apartment for sale of 98 square meters plus upper floor, under cover, of 85 square meters. in the Plaza de la Industria area. The apartment is completely exterior, has clear views and receives sunlight all day. It is distributed as follows: - 1 large and comfortable entrance hall. - 2 spacious and bright rooms. - 1 medium room with natural light. - 1 small room with a window to the Laundry Room. - 1 very bright living room. - 1 large main bathroom, with exterior window. - 1 Bathroom with storage cabinets (under one of the built-in cabinets there is a shower tray with the option to enable it), exterior window. - Very spacious and bright kitchen with laundry room. Complementing the main house we have a gloomy lower deck of about 85 square meters, with 2 balconies with partial views of the sea, which could be joined to the main floor and converted into a spectacular duplex. The house does not have an elevator or a parking space, but it is possible to purchase or rent one in a recently built nearby building. Located a few meters from Plaza de la Industria and Plaza América, so it is very well connected by public transport to the rest of the city's neighborhoods and close to the beach area and Bouzas. Next to the Chouzo school, near the School of Industrial Engineering (Peritos), near the Faculty of Commerce, near the IES Politécnico. Ideal for large families, families with businesses or investors (it is in an area with a lot of rental demand from students).

Reference:

451379

Size:

98m²

Usable size:

85m²

Bedrooms:

4

Bathrooms:

1

Furnished:

Partially furnished

Garage:

No

Floor:

3rd

Lounges:

1

Furnished kitchen:

Semi-furnished

Kitchen type:

Independent

WCs:

1

Balconies:

2

Location:

Exterior

Orientation:

East, West

Views:

Distant sea, City

Ceiling height:

Regular

Type of ceiling:

Plaster

Finishing carpentry :

Wood

Walls:

Flat

Floors:

Others, Parquet

Type of windows:

Aluminum, Blinds

Type of glazing:

Single

Storage room:

Yes

Hot water:

Individual

Type hot water:

Butane

No. of floors:

3

Lift:

No

Neighbors:

1

Neighbors in the building:

3

Style:

Classic

Facade:

Others

Building year:

1964 (60 year/s)

Condition:

Needs some renovation

Availability:

Unoccupied

Equipment:

Antenna, Phone line, Refrigerator, Dryer, Oven, , , Water, Light, Gas, Appliances, Intercom, Bathtub

Comunity fee:

60€

Details and photos

Saians, Vigo, Pontevedra

Chalet for sale

36 1

RefRASO-451147 🔗

URGENT

285.000€

Vía PRAIA-SAIANS

Villa in Saians with excellent views of the Cíes Islands.

Detached villa in Saians, sunny and totally exterior. It has a large 40 m2 terrace with excellent views of both the Cíes Islands and the Ría de Vigo. It is a two-story house, with 162 m² useful distributed as follows: Low level: - Small hall. - Living room with fireplace. - Built-in wardrobe and small pantry. - Large fully equipped kitchen. - Dining room with access to a 90 m2 garden. - Bathroom with shower tray. - Garage with capacity for a car and a motorcycle. First floor: - Three bedrooms with built-in wardrobes, two of them with access to a large terrace with excellent views. - A full main bathroom. It should be noted that the large terrace is partially covered, which has fantastic views of both the Cíes Islands and the Ría de Vigo and that from it you can enjoy spectacular sunsets (without the possibility of building in front of the property). Mention that the garden is in the back, which provides tranquility, it currently has trees but, if preferred, a pool can be installed. The garage has capacity for one car and one motorcycle, with the possibility of another parking space in a private parking area in front of the house. Diesel boiler for both hot water and heating, wooden floors throughout the home and ceramic tiles in the dining room, kitchen and bathrooms. Good location, just 300 meters from Fortiñón beach, 2 km from Patos beach, 3 km from Nigrán, 4 km from Playa América and 9 km from the center of Vigo. With bus stops 50 meters from the house: both the Vigo city bus (Vitrasa), the line from Vigo to Baiona, and the school bus. Great property to enjoy or rent in the summer season and if you prefer all year round, given its amenities. An ideal place to get in touch with nature and enjoy both the beach and the green areas, and at the same time close to the center of Vigo.

Reference:

451147

Size:

202m²

Usable size:

162m²

Plot size:

90m²

Bedrooms:

3

Bathrooms:

2

Furnished:

Partially furnished

Garage:

Private (1 Parking places)

Garage type:

Closed

Garden:

Private (90.00m²)

Lounges:

1

Built-in cupboards:

Yes

Independent dining room:

Yes

Furnished kitchen:

Furnished

Kitchen type:

Independent

Terraces:

1 (40.00m²)

Location:

Exterior

Orientation:

West

Location:

Near the beach, Residential area

Views:

Direct sea, Sea, Country, Mountain, Street, Estuary

Ceiling height:

Regular

Type of ceiling:

Plaster

Finishing carpentry :

Sapeli

Walls:

Flat

Floors:

Stoneware, Floating wood

Type of windows:

Aluminum, Blinds

Type of glazing:

Double glazing

Storage room:

Yes

Basement:

No

Hot water:

Yes

Type hot water:

Diesel

Heating:

Yes

Heating type:

Diesel fuel

No. of floors:

2

Facade:

Others

Building year:

2000 (24 year/s)

Condition:

Good

Availability:

Unoccupied

Equipment:

Antenna, Phone line, Internet, Wifi, Refrigerator, Washing machine, Oven, Microwave, Water, Light, Appliances, Chimney, Ceramic hob, Bathtub, Shower plate

Details and photos

Nigrán, Pontevedra

Chalet for sale

67 1

RefRASO-451008 🔗

INVESTORS

1.326.000€

Spectacular villa in Playa América

Spectacular villa in Playa América. It is a large 3-story house, with seven bedrooms and 6 bathrooms, a huge 80 m² pool, an attached garage with capacity for 4 vehicles on a beautifully landscaped 2,117 m² plot, located 200 m2 from the beach. From the chalet you can enjoy magnificent sunsets and sea views. Its living room is divided into two rooms, one with a large dining room and another more secluded by the warmth of the fireplace. VERY IMPORTANT: The progress of the next PXOM contemplates that in the part of the plot closest to the beach a 4-story building can be built, so a great capital gain can be obtained and in addition the chalet would continue to retain a large property at its disposal. around. The chalet can also be divided into three independent homes, occupying one for each floor. THIS INFORMATION IS NOT BINDING AND SHOULD BE VERIFIED BY THE INVESTOR. THE URBAN PLANNING PARAMETERS CONTEMPLATED IN THE PROGRESS OF THE PXOM MAY SUFFER VARIATIONS IN THE FINAL APPROVAL OF THE PXOM.

Reference:

451008

Size:

611m²

Plot size:

2.117m²

Bedrooms:

7

Bathrooms:

6

Furnished:

Partially furnished

Garage:

Private (4 Parking places)

Garage type:

Covered

Swimming pool:

Private (12x7m.)

Garden:

Private

Built-in cupboards:

Yes

Independent dining room:

Yes

Furnished kitchen:

Furnished with appliances

Kitchen type:

Independent

Location:

Exterior

Orientation:

North, East, South, West

Location:

Beachfront

Views:

Direct sea, Sea, Pool

Ceiling height:

Regular

Type of ceiling:

Plaster, Wood

Walls:

Flat

Floors:

Stoneware, Parquet

Type of windows:

Wood

Storage room:

Yes

Basement:

Yes

Hot water:

Yes

Type hot water:

Natural gas

Heating:

Yes

Heating type:

Natural gas

No. of floors:

3

Lift:

No

Style:

Classic

Building year:

1984 (40 year/s)

Condition:

Excellent

Availability:

Unoccupied

Equipment:

Antenna, Refrigerator, Washing machine, Dishwasher, Microwave, , Water, Barbecue, Chimney, Bathtub, Shower plate, Cellar

Details and photos

Centro, Coruña (A), La Coruña (A Coruña)

Flat for sale

47

RefRASO-449116 🔗

FEATURED

380.000€

Calle CORDONERIA

Reference:

449116

Size:

118m²

Usable size:

110m²

Bedrooms:

4

Bathrooms:

2

Furnished:

Partially furnished

Garage:

No

Floor:

5th

Built-in cupboards:

Yes

Furnished kitchen:

Furnished with appliances

Kitchen type:

Independent

Location:

Exterior

Views:

City

Ceiling height:

Regular

Storage room:

Yes

Lift:

Yes

Neighbors:

2

Building year:

1980 (44 year/s)

Condition:

Excellent

Handicapped access:

Yes

Details and photos

Tomiño, Pontevedra

Chalet for sale

54 1

RefRASO-448987 🔗

JUST IN

299.000€

Lugar Vidancelle

SPACIOUS STONE VILLA IN TOMIÑO

Isolated stone villa for sale with an area of ​​440 square meters, 400 useful square meters. It is built on a plot of land with 1,394 square meters, which has grass, a growing area, a laundry area, etc. The house has four floors (basement, ground floor, first floor and basement). The facilities are located in the basement, which also serves as a warehouse. On the ground floor there is the hall, a kitchen, a bedroom (currently used as a sewing room), a toilet, a living-dining room with a fireplace and a porch. On the first floor is the master bedroom with bathroom and built-in wardrobe, two bedrooms with built-in wardrobes, one bedroom (currently used as a living room), another full bathroom and two large terraces. On the lower deck, where it is necessary to complete certain finishes, there are four bedrooms with built-in wardrobes (one of them with a bathroom) and another full bathroom, two terraces. It has an armored door, alarm with presence detector, smoke detector, diesel heating, automatic gate, automatic irrigation, wood stove connected to the heating and hot water system, country stone closure, solar panels and covered pool. The property has an annex where a second kitchen, a bathroom, a storage area and a garage for two cars are located; as well as a gazebo with stone table, barbecue and oven. Very quiet and sunny place, located in Tomiño and very close to A Guarda and Tui.

Reference:

448987

Size:

440m²

Usable size:

400m²

Plot size:

1.394m²

Bedrooms:

9

Bathrooms:

5

Furnished:

Partially furnished

Garage:

Private (2 Parking places)

Garage type:

Closed

Swimming pool:

Private

Garden:

Private

Lounges:

1

Independent dining room:

Yes

Furnished kitchen:

Furnished without appliances

Kitchen type:

Independent

WCs:

1

Terraces:

8

Location:

Exterior

Location:

Rural area

Views:

Country, Mountain, River

Ceiling height:

Regular

Type of ceiling:

Plaster

Finishing carpentry :

Oak

Walls:

Flat

Floors:

Stoneware, Floating wood

Type of windows:

Wood

Type of glazing:

Double glazing

Storage room:

Yes

Basement:

Yes

Hot water:

Individual

Type hot water:

Diesel

Heating:

Individual

Heating type:

Diesel fuel

No. of floors:

4

Lift:

No

Style:

Classic

Facade:

Stone

Building year:

2014 (10 year/s)

Condition:

Excellent

Availability:

occupied by owner

Equipment:

Satellite dish, Phone line, Oven, Water, Light, Barbecue, Chimney, Intercom, Shower plate, Cellar, Porch

Security measures:

Alarm, Others

Doorman:

No

Handicapped access:

No

Details and photos

Santiago de Compostela, La Coruña (A Coruña)

Duplex for sale

42

RefRASO-448725 🔗

Ref2.santiago p

FEATURED

330.000€

Calle londres

Reference:

448725 - santiago p

Size:

150m²

Bedrooms:

4

Bathrooms:

3

Furnished:

Not furnished

Garage:

Private (1 Parking places)

Garage type:

Carport

Garden:

Comunitary

Lounges:

2

Built-in cupboards:

Yes

Furnished kitchen:

Furnished with appliances

Kitchen type:

Independent

Suites:

2

Location:

Exterior

Orientation:

Southwest

Location:

Residential area

Views:

Country, City, Urbanization

Ceiling height:

Regular

Type of ceiling:

Plaster, Plates

Finishing carpentry :

Chestnut

Walls:

Flat

Floors:

Porcelain stoneware, Parquet

Type of windows:

Aluminum

Storage room:

Yes

Hot water:

Yes

Type hot water:

Natural gas

Heating:

Yes

Heating type:

Natural gas

Lift:

Yes

Facade:

Stone

Condition:

Excellent

Availability:

occupied by owner

Security measures:

Alarm

Details and photos

Someso, Coruña (A), La Coruña (A Coruña)

Parking space for sale

15

RefRASO-448363 🔗

Ref2.SBRE-0163826

JUST IN

from 2.000€

Calle Luis Peña Novo, 8

Reference:

448363 - SBRE-0163826

Size:

10m²

Usable size:

6m²

Floor:

Basement -2

Basement:

Yes

Details and photos

Centro, Vigo, Pontevedra

Flat for sale

19 1

RefRASO-447348 🔗

RESERVED

229.000€

Calle República Argentina, 6

IDEAL INVESTORS. FLAT IN THE CENTER OF VIGO, IN REPUBICA ARGENTINA

Rasolenia exclusively sells this two-bedroom apartment located in the best area of Vigo. It is accessed from República Argentina Street and is located between Arenal and Rosalía de Castro Streets. The apartment consists of two bedrooms, bathroom and toilet both renovated, separate kitchen, living room and two balconies. One balcony is accessed from the master bedroom and the other from the living room. It also has a covered patio, so the apartment is ideal for pets. Garage space and storage room included in the price. Heating and hot water are central and included in the community fee. The apartment is located in the best area of Vigo, where the central offices of banks, notaries, schools and institutes are located, close to the port, shipping agents and the largest service companies. That is why the apartment is ideal for investors since the profitability in traditional rental is guaranteed. It is also very profitable as a VUT given its proximity to the two train stations, the marina, the leisure and restaurant area, the epicentre of the Christmas lights and the main shopping centres.

Reference:

447348

Size:

78m²

Usable size:

68m²

Bedrooms:

2

Bathrooms:

1

Furnished:

Partially furnished

Garage:

Comunitary (1 Parking places)

Garage type:

Carport

Floor:

1st

Lounges:

1 (19.00m²)

Built-in cupboards:

Yes

Furnished kitchen:

Furnished

Kitchen type:

Independent

WCs:

1

Terraces:

2 (8.00m²)

Courtyards:

1

Location:

Exterior

Orientation:

East

Location:

City center

Views:

Sea, City

Ceiling height:

Regular

Type of ceiling:

Plaster

Finishing carpentry :

Sapeli

Walls:

Flat

Floors:

Stoneware, Parquet

Type of windows:

Aluminum, Blinds

Type of glazing:

Single

Storage room:

Yes

Hot water:

Centralized

Type hot water:

Diesel

Heating:

Centralized

Heating type:

Diesel fuel

Lift:

Yes

Neighbors:

4

Facade:

Others

Building year:

1979 (45 year/s)

Condition:

Average

Availability:

occupied by owner

Equipment:

Antenna, Phone line, Water, Light, Intercom, Shower plate

Yard size:

8.00m²

Handicapped access:

No

Details and photos

A Pedreira, Arteixo, La Coruña (A Coruña)

Chalet for sale

26

RefRASO-442700 🔗

Ref2.ArtanC

PROPERTY OF THE MONTH

1.400.000€

Reference:

442700 - ArtanC

Size:

700m²

Usable size:

640m²

Plot size:

3.000m²

Bedrooms:

4

Bathrooms:

4

Furnished:

Fully furnished

Garage:

Private (2 Parking places)

Garage type:

Closed

Swimming pool:

Private

Garden:

Private (2929.00m²)

Lounges:

4

Built-in cupboards:

Yes

Independent dining room:

Yes

Furnished kitchen:

Furnished with appliances

Kitchen type:

American

Suites:

4

WCs:

2

Location:

Exterior

Orientation:

South, Southwest

Location:

Near the beach, Not far from the beach

Views:

Distant sea, Country

Ceiling height:

Regular

Finishing carpentry :

Oak

Walls:

Rustic

Floors:

Porcelain stoneware, Marble, PVC

Type of windows:

Aluminum, Oscillating, PVC

Type of glazing:

Double glazing, Soundproof, Thermal bridge

Storage room:

Yes

Hot water:

Centralized

Type hot water:

Diesel

Heating:

Centralized

Heating type:

Diesel fuel

No. of floors:

3

Style:

Modern

Facade:

Stone

Building year:

2003 (21 year/s)

Condition:

Excellent

Equipment:

TV, Stereo, Satellite dish, Muzak, Phone line, Internet, Wifi, Refrigerator, Washing machine, Dryer, Dishwasher, Oven, Microwave, Video intercom, , , Barbecue, Chimney, Jacuzzi, Solarium, Domotics, hydromassage, Shower plate, Cellar, Porch

Sport facilities:

Tennis

Security measures:

Alarm, Video-surveillance

Handicapped access:

Yes

Details and photos

Montealto, Coruña (A), La Coruña (A Coruña)

Commercial premise for sale

11

RefRASO-438835 🔗

Ref2.SBRE-0152118

JUST IN

77.000€

Ronda Monte Alto, 60

Reference:

438835 - SBRE-0152118

Size:

83m²

Usable size:

79m²

Furnished:

Not furnished

Garage:

No

Floor:

Street level

Ceiling height:

High

Storage room:

No

Basement:

No

Lift:

No

Urbanization:

No

Condition:

To renovate/modernise

Availability:

Unoccupied

Doorman:

No

Environment:

Street

Number of separated areas:

1

Front width:

4.00m.

Details and photos

Los Castros, Coruña (A), La Coruña (A Coruña)

Parking space for sale

12

RefRASO-438325 🔗

GOOD DEAL

17.500€

Avenida oza, 168

Reference:

438325

Size:

12m²

Floor:

Basement -2

Details and photos

Matogrande, Coruña (A), La Coruña (A Coruña)

Commercial premise for sale

30

RefRASO-420248 🔗

Ref2.7237444

BANK PROPERTY

185.000€

Calle José Pascual López-Cortón, 2

Reference:

420248 - 7237444

Size:

255m²

Usable size:

253m²

Garage:

No

Floor:

1st

Location:

Exterior

Storage room:

Yes

No. of floors:

1

Condition:

To renovate/modernise

Horizontal division:

Yes

Handicapped access:

No

Details and photos

Matogrande, Coruña (A), La Coruña (A Coruña)

Commercial premise for sale

28

RefRASO-420247 🔗

Ref2.7237443

BANK PROPERTY

150.000€

Calle José Pascual López-Cortón, 2

Reference:

420247 - 7237443

Size:

199m²

Usable size:

188m²

Garage:

No

Floor:

1st

Location:

Exterior

Storage room:

Yes

No. of floors:

1

Condition:

To renovate/modernise

Horizontal division:

Yes

Handicapped access:

No

Details and photos

Narón, La Coruña (A Coruña)

Industrial plot for sale

6

RefRASO-420097 🔗

Ref2.5954622

GOOD DEAL

from 33.800€

Plot for sale in Naron calle lagoas (rua cento vinte)

The land is located on Calle Lagos de Covadonga (Rúa Centro Vinte), in the municipality of Narón, for industrial use, on the land an 875 m² warehouse could be built.

Reference:

420097 - 5954622

Size:

3.400m²

Details and photos

Ferrol, La Coruña (A Coruña)

Chalet for sale

30

RefRASO-419941 🔗

Ref2.PM136894

GOOD DEAL

209.000€

Detached villa for sale Vilela 33, Ferrol, A Coruña

Detached villa for sale, located in Ferrol, province of A Coruña. This second-hand home has a constructed area of ​​355 m². It is distributed over three floors and has 9 bedrooms, 3 bathrooms, a living-dining room, an independent kitchen, a hall, a garage, various storage rooms, a porch and a garden. Located in an area with all kinds of services and easy access, either by public or private transport.

Reference:

419941 - PM136894

Size:

355m²

Usable size:

309m²

Bedrooms:

9

Bathrooms:

3

Furnished:

Not furnished

Garage:

Private (1 Parking places)

Garage type:

Covered

Swimming pool:

No

Garden:

Private

Lounges:

1

Built-in cupboards:

Yes

Independent dining room:

Yes

Furnished kitchen:

Furnished

Kitchen type:

Independent

Location:

Exterior

Orientation:

North

Location:

Rural area

Views:

Mountain

Ceiling height:

Regular

Type of ceiling:

Plaster

Finishing carpentry :

Mahogany

Walls:

Cement

Floors:

Ceramic

Type of windows:

Iron

Type of glazing:

Double glazing

Storage room:

Yes

Hot water:

Centralized

Heating:

Centralized

No. of floors:

3

Lift:

No

Urbanization:

No

Style:

Classic

Facade:

Cement

Condition:

Good

Availability:

Unoccupied

Emission efficiency value:

79kg/m2/año

Consumption efficiency value:

307kg/m2/año

Equipment:

Water, Bathtub, Cellar

Security measures:

Others, Grille

Details and photos

Someso, Coruña (A), La Coruña (A Coruña)

Parking space for sale

15

RefRASO-419903 🔗

Ref2.SBRE-0163823

JUST IN

from 1.900€

Calle Luis Peña Novo, 8

Reference:

419903 - SBRE-0163823

Size:

4m²

Usable size:

3m²

Floor:

Basement -1

Basement:

Yes

Details and photos

Centro, Valdoviño, La Coruña (A Coruña)

Flat for sale

19

RefRASO-419813 🔗

Ref2.PM133752

SPECIAL MONTH OFFER

83.000€

Apartment for sale in Valdovino

Apartment for sale, Av Almirante Pedro Fernández, Valdoviño, Coruña, the apartment has three bedrooms, a bathroom, living room and kitchen. Its excellent location allows all services to be within reach, such as financial institutions, supermarkets, bars and restaurants. It is also very close to the beautiful beach of Valdoviño. It is in a great offer with reduced price.

Reference:

419813 - PM133752

Size:

112m²

Usable size:

112m²

Bedrooms:

3

Bathrooms:

1

Furnished:

Not furnished

Garage:

No

Independent dining room:

Yes

Furnished kitchen:

Not

Kitchen type:

Independent

Location:

Exterior

Orientation:

Northeast

Location:

Near the beach

Views:

Street

Ceiling height:

Regular

Type of ceiling:

Vaulted

Finishing carpentry :

Mahogany

Walls:

Cement

Floors:

Ceramic

Type of windows:

Aluminum

Type of glazing:

Single

Storage room:

No

Hot water:

Centralized (private meter)

Type hot water:

Natural gas

Heating:

Individual

Heating type:

Propane

Lift:

No

Neighbors in the building:

2

Style:

Modern

Facade:

Cement

Condition:

Good

Availability:

Unoccupied

Equipment:

Water

Security measures:

Security door

Doorman:

No

Handicapped access:

No

Details and photos

Narón, La Coruña (A Coruña)

Building for sale

6

RefRASO-418042 🔗

Ref2.6035800600

GOOD DEAL

831.200€

Calle lucas

Work stopped for sale in calle Lucas,15-17(esq.c/areosa-c/san Avelino), Narón, A Coruña

Land for sale in Narón A Coruña. OBRA PARADA, is a plot of 1102.31 m² and with a buildable area of ​​5043.99 m², it is a building under construction, it consists of 54 homes, which include 2 basements that are They will be used for garages and storage rooms. The construction is located in the center of the town, very close to the Town Hall of Narón (approximately 1 km), its excellent geolocation allows it to be surrounded by shops, supermarkets, bars and restaurants. In addition, it is located very close to the AC-862 highway, a fast road that crosses the entire population and connects with the AP-9 in less than 5 minutes, so it enjoys good communications. And it allows you to be in a Coruña and its airport in just under an hour. It is a good investment opportunity.

Reference:

418042 - 6035800600

Size:

1.102m²

Usable size:

5.043m²

Bathrooms:

60

Garage:

Private (54 Parking places)

Garage type:

Closed

Garden:

No

Location:

Exterior

Orientation:

Northwest

Ceiling height:

Regular

Type of ceiling:

Plaster

Finishing carpentry :

Mahogany, Wood

Walls:

Cement

Floors:

Polished concrete

Storage room:

Yes

Hot water:

Individual

Lift:

No

Style:

Modern

Facade:

Brick

Condition:

Under construction

Availability:

Unoccupied

Security measures:

Grille

Doorman:

No

Floors over street level:

5

Handicapped access:

No

Details and photos

New properties

Would you like to receive by email the properties we include in the website?

PurchaseRentalTransfer

Accept Privacy policy